
from openpyxl import Workbook
from openpyxl import load_workbook
from base.base_common import BaseCommon




# file_path = 'F:\\test4hjx_glht\\data\\订单批量导入模板.xlsx'
# # 打开文件，获取工作簿
# wb = load_workbook(file_path)
# #
# worksheet1 = wb[wb.sheetnames[0]]
# # print(worksheet1)
#
#
# worksheet1.cell(2, 1).value = '5960570770'
# worksheet1.cell(2, 3).value = '18776136754'
# worksheet1.cell(2, 5).value = '34875947699566'
# wb.save("订单批量导入模板.xlsx")
#
# cel = worksheet1.cell(2,1)
# print(cel.value)


# sheet = wb["订单批量导入模板"]

# for i in range(2, 3):
#     worksheet1.cell(i, 1).value = "0999"
#     # worksheet1.cell(i,2).value = "09990"
#     print(i)
#
#     wb.save(file_path)






# # 获取工作簿中的工作表
# sheet = wb.active

# # 遍历所有单元格
# for row in sheet.iter_rows(min_row=2, min_col=1, max_row=sheet.max_row, max_col=sheet.max_column):
#     for cell in row:
#         cell.value = "New Value"

# 保存修改
# wb.save('订单批量导入模板.xlsx')

def fgfg (self):
    BaseCommon.generateStu1(self)